Kelly Moore
Kelly Moore
-
Discreetly Alert Users When Summary Field is Present
The Sheet Summary Fields can be incredibly useful in providing sheet instructions or other sharable information to sheet users, however the summary fields are one of the best kept secrets for many us…3 · -
Re: Creating a unique ID based on two other columns
Hey @laura_bfo The solution below requires one system helper column - either [Row ID] or Created column. This also assumes the rows are going down the page in chronological order. If this isn't true,…1 · -
Re: Count String Occurrence in a Cell
Hey @Nazeer Sayyed See if this will work for you =(LEN([Status (Delivered)]@row) - LEN(SUBSTITUTE([Status (Delivered)]@row, "Delivered", ""))) / LEN("Delivered") This is…5 · -
Re: restrict checking check boxes
Hey @Vinton Douglas How are your users inputting the data? From a form, from a sheet, from a dynamic view…? If they are directly using the sheet, there is no great way to limit access. Locking a colu…1 · -
Re: Function for Counting Children of Parent Rows
Hey @JamesQ4 Unfortunately, children cannot be directly used as cross sheet ranges. The work around is to add a helper column to your source sheet that can be used to find the child rows. You can do …1 ·
